Dashboard in a Day - Online workshop

At a glance

Level : Beginner

Product : Power BIMicrosoft Power Platform

Role : Business AnalystBusiness User

Basic knowledge of Excel and data analysis concepts

Power BI Desktop installed (latest version)

Live practice session with real-world datasets

Outcome: By the end of the session, students will have built a fully functional Power BI dashboard and gained the foundational skills to explore more advanced analytics in Power BI.

Morning Session

Introduction and Prerequisites for Power BI

• Overview of Power BI and its components
• Setting up the required software

Access and Prepare Data for Power BI Desktop

• Connecting to various data sources
• Data transformation and preparation techniques

Build Your First Data Model and Explore the Data Using Power BI

• Creating relationships between data tables
• Developing data visualizations
• Grouping and binning data
• Creating a date table

Afternoon Session

Use Hierarchies and DAX in Your First Data Model

• Implementing data hierarchies
• Introduction to Data Analysis Expressions (DAX)
• Utilizing matrix visualizations

Data Visualization and Reports in Power BI

• Applying conditional formatting
• Incorporating logos and custom themes
• Completing and refining reports

Import Custom Visuals and Add Bookmarks to a Report in Power BI

• Enhancing reports with custom visuals
• Using bookmarks for navigation and storytelling

Publish and Access Reports in Power BI Service

• Publishing reports to the Power BI Service
• Creating dashboards
• Exploring mobile views
• Integrating Power BI with PowerPoint

Interact, Share, and Collaborate on Power BI Dashboards

Sharing dashboards with others

Collaborative features and best practices

Accessing dashboards on mobile devices